//项目表中添加了三个新字段
CREATE TABLE [dbo].[bos_project] (
  [id] int IDENTITY(1,1) NOT NULL,
  [wType] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [wName] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [sTime] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [eTime] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [progess] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [pdetail] varchar(225) COLLATE Chinese_PRC_CI_AS NULL,
  [leader] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [groups] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [checker] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [kehuer] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [others1] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [others2] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [remarks] varchar(100) COLLATE Chinese_PRC_CI_AS NULL,
  [bid] int NULL,
  [update_time] datetime NULL,
  [sAddress] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [firstParty] varchar(100) COLLATE Chinese_PRC_CI_AS NULL,
  [linkman] varchar(100) COLLATE Chinese_PRC_CI_AS NULL,
  CONSTRAINT [PK__bos_proj__3213E83F108B795B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[bos_project] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'订阅人，对应的是customer表里的数据',
'SCHEMA', N'dbo',
'TABLE', N'bos_project',
'COLUMN', N'others1'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目地点',
'SCHEMA', N'dbo',
'TABLE', N'bos_project',
'COLUMN', N'sAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'甲方',
'SCHEMA', N'dbo',
'TABLE', N'bos_project',
'COLUMN', N'firstParty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'甲方联系人',
'SCHEMA', N'dbo',
'TABLE', N'bos_project',
'COLUMN', N'linkman'